package com.jk.order.mapper;

import com.jk.order.pojo.CustomerOrder;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface OrderMapper {
    
    @Select("select * from customerorder")
    public List<CustomerOrder> getAllOrders();

    @Select("SELECT * from customerorder where customerOrderId=#{OrderId}")
    public CustomerOrder getOrderfromfId(String OrderId);

    @Insert("INSERT INTO customerorder(Id,customerId,customerOrderFinishDate,customerOrderId,customerOrderMoney,customerOrderNumber,customerOrderState,flowerId,orderStartDate)")
    public void insertOrder(CustomerOrder Order);

}
